Overview: .NET Script

Add one or more fields to the existing dataset by writing an script in either C# (C Sharp) or VB.NET (Visual Basic .NET) languages. The values of the new fields will be determined by the programmed script, can either be a valid value or a null entry, and can be of any data type.  

You may define any variable from the standard .NET namespace in the script itself, or as a state variable if you want to keep values intact between executes.

NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.

Script execution

The script is run from top to bottom for each row, every time the data recipe operation executes.

Note that if your script enters an infinite loop, the software may become unresponsive.

Limitations

Read more on limitations of the .NET script.

Properties

Category:

Add

Performance risk:

High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset.

Knowledge required:

Working knowledge of a .NET language required

 

Effect on datasets

How many datasets are required to perform this operation?

One

Does it create a new dataset?

No

Can you reconfigure this operation?

Yes

Can you apply this operation to a locked dataset?

No

Does it modify the current dataset in any way?

Yes

Requirements

  • A dataset that contains at least one field of any data type.

Results

  • The dataset will be modified to contain the newly added fields.

  • The output values for the new fields can either be valid values or null entries, and will be determined by the programmed script.


Related topics:

  

CSense 2023- Last updated: November 17,2023